using System;
using System.Data;
using System.Data.SqlClient;

public class <OwnerU>_<TableU>DataClass
{

    public static DataTable Select_Records(<DRType> <DRField>)
    {
        SqlConnection connection = <Database>DataClass.GetConnection();
        string selectStatement
            = "SELECT "  
            <If Loop>
               <IsComboBox (Db)>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow=[0]>
            + "     [A<MiscTag>].[<RDisplayField>] "
               <IsComboBox (Db)>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow<>[0]>
            + "    ,[A<MiscTag>].[<RDisplayField>] "
               <IsComboBox (Db)>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow=[0]>
            + "     [<ROwner>].[<RTable>].[<RDisplayField>] "
               <IsComboBox (Db)>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow<>[0]>
            + "    ,[<ROwner>].[<RTable>].[<RDisplayField>] "
               <IsNotComboBox (Db)>
               <And>
               <IsCurRow=[0]>
            + "     [<Owner>].[<Table>].[<Field>] "
               <IsNotComboBox (Db)>
               <And>
               <IsCurRow<>[0]>
            + "    ,[<Owner>].[<Table>].[<Field>] "
            </If Loop>
            + "FROM " 
            + "     [<Owner>].[<Table>] " 
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNull>
            + "LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNull>
            + "LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNotNull>
            + "INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNotNull>
            + "INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
            </If Loop>
            + "WHERE "
            + "     [<DOwner>].[<DTable>].[<DRField>] = @<DRField> "
            + "";
        SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
        selectCommand.CommandType = CommandType.Text;
        selectCommand.Parameters.AddWithValue("@<DRField>", <DRField>);
        DataTable dt = new DataTable();
        try
        {
            connection.Open();
            SqlDataReader reader = selectCommand.ExecuteReader();
            if (reader.HasRows) {
                dt.Load(reader); }
            reader.Close();
        }
        catch (SqlException)
        {
            return dt;
        }
        finally
        {
            connection.Close();
        }
        return dt;
    }

    public static DataTable Search(<DRType> <DRField>, string sField, string sCondition, string sValue)
    {
        SqlConnection connection = <Database>DataClass.GetConnection();
        string selectStatement = "";
        if (sCondition == "Contains") {
            selectStatement
                = "SELECT "
            <If Loop>
               <IsComboBox (Db)>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow=[0]>
            + "     [A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]"
               <IsComboBox (Db)>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow<>[0]>
            + "    ,[A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]"
               <IsComboBox (Db)>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow=[0]>
            + "     [<ROwner>].[<RTable>].[<RDisplayField>] "
               <IsComboBox (Db)>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow<>[0]>
            + "    ,[<ROwner>].[<RTable>].[<RDisplayField>] "
               <IsNotComboBox (Db)>
               <And>
               <IsCurRow=[0]>
            + "     [<Owner>].[<Table>].[<Field>] "
               <IsNotComboBox (Db)>
               <And>
               <IsCurRow<>[0]>
            + "    ,[<Owner>].[<Table>].[<Field>] "
            </If Loop>
            + "FROM " 
            + "     [<Owner>].[<Table>] " 
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNull>
            + "LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNull>
            + "LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNotNull>
            + "INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNotNull>
            + "INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
            </If Loop>
            + "WHERE "
            + "     [<DOwner>].[<DTable>].[<DRField>] = @R<DRField> "
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] LIKE '%' + LTRIM(RTRIM(@<RDisplayField><MiscTag>)) + '%') " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] LIKE '%' + LTRIM(RTRIM(@<RDisplayField><MiscTag>)) + '%') " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] LIKE '%' + LTRIM(RTRIM(@<RDisplayField>)) + '%') " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] LIKE '%' + LTRIM(RTRIM(@<RDisplayField>)) + '%') " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] LIKE '%' + LTRIM(RTRIM(@<Field>)) + '%') " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] LIKE '%' + LTRIM(RTRIM(@<Field>)) + '%') " 
</If Loop>
                + "";
        } else if (sCondition == "Equals") {
            selectStatement
                = "SELECT "
            <If Loop>
               <IsComboBox (Db)>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow=[0]>
            + "     [A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]"
               <IsComboBox (Db)>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow<>[0]>
            + "    ,[A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]"
               <IsComboBox (Db)>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow=[0]>
            + "     [<ROwner>].[<RTable>].[<RDisplayField>] "
               <IsComboBox (Db)>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow<>[0]>
            + "    ,[<ROwner>].[<RTable>].[<RDisplayField>] "
               <IsNotComboBox (Db)>
               <And>
               <IsCurRow=[0]>
            + "     [<Owner>].[<Table>].[<Field>] "
               <IsNotComboBox (Db)>
               <And>
               <IsCurRow<>[0]>
            + "    ,[<Owner>].[<Table>].[<Field>] "
            </If Loop>
            + "FROM " 
            + "     [<Owner>].[<Table>] " 
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNull>
            + "LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNull>
            + "LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNotNull>
            + "INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNotNull>
            + "INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
            </If Loop>
            + "WHERE "
            + "     [<DOwner>].[<DTable>].[<DRField>] = @R<DRField> "
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] = LTRIM(RTRIM(@<RDisplayField><MiscTag>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] = LTRIM(RTRIM(@<RDisplayField><MiscTag>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] = LTRIM(RTRIM(@<RDisplayField>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] = LTRIM(RTRIM(@<RDisplayField>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] = LTRIM(RTRIM(@<Field>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] = LTRIM(RTRIM(@<Field>))) " 
</If Loop>
                + "";
        } else if  (sCondition == "Starts with...") {
            selectStatement
                = "SELECT "
            <If Loop>
               <IsComboBox (Db)>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow=[0]>
            + "     [A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]"
               <IsComboBox (Db)>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow<>[0]>
            + "    ,[A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]"
               <IsComboBox (Db)>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow=[0]>
            + "     [<ROwner>].[<RTable>].[<RDisplayField>] "
               <IsComboBox (Db)>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow<>[0]>
            + "    ,[<ROwner>].[<RTable>].[<RDisplayField>] "
               <IsNotComboBox (Db)>
               <And>
               <IsCurRow=[0]>
            + "     [<Owner>].[<Table>].[<Field>] "
               <IsNotComboBox (Db)>
               <And>
               <IsCurRow<>[0]>
            + "    ,[<Owner>].[<Table>].[<Field>] "
            </If Loop>
            + "FROM " 
            + "     [<Owner>].[<Table>] " 
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNull>
            + "LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNull>
            + "LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNotNull>
            + "INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNotNull>
            + "INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
            </If Loop>
            + "WHERE "
            + "     [<DOwner>].[<DTable>].[<DRField>] = @R<DRField> "
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] LIKE LTRIM(RTRIM(@<RDisplayField><MiscTag>)) + '%') " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] LIKE LTRIM(RTRIM(@<RDisplayField><MiscTag>)) + '%') " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] LIKE LTRIM(RTRIM(@<RDisplayField>)) + '%') " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] LIKE LTRIM(RTRIM(@<RDisplayField>)) + '%') " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] LIKE LTRIM(RTRIM(@<Field>)) + '%') " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] LIKE LTRIM(RTRIM(@<Field>)) + '%') " 
</If Loop>
                + "";
        } else if  (sCondition == "More than...") {
            selectStatement
                = "SELECT "
            <If Loop>
               <IsComboBox (Db)>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow=[0]>
            + "     [A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]"
               <IsComboBox (Db)>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow<>[0]>
            + "    ,[A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]"
               <IsComboBox (Db)>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow=[0]>
            + "     [<ROwner>].[<RTable>].[<RDisplayField>] "
               <IsComboBox (Db)>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow<>[0]>
            + "    ,[<ROwner>].[<RTable>].[<RDisplayField>] "
               <IsNotComboBox (Db)>
               <And>
               <IsCurRow=[0]>
            + "     [<Owner>].[<Table>].[<Field>] "
               <IsNotComboBox (Db)>
               <And>
               <IsCurRow<>[0]>
            + "    ,[<Owner>].[<Table>].[<Field>] "
            </If Loop>
            + "FROM " 
            + "     [<Owner>].[<Table>] " 
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNull>
            + "LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNull>
            + "LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNotNull>
            + "INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNotNull>
            + "INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
            </If Loop>
            + "WHERE "
            + "     [<DOwner>].[<DTable>].[<DRField>] = @R<DRField> "
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] > LTRIM(RTRIM(@<RDisplayField><MiscTag>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] > LTRIM(RTRIM(@<RDisplayField><MiscTag>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] > LTRIM(RTRIM(@<RDisplayField>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] > LTRIM(RTRIM(@<RDisplayField>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] > LTRIM(RTRIM(@<Field>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] > LTRIM(RTRIM(@<Field>))) " 
</If Loop>
                + "";
        } else if  (sCondition == "Less than...") {
            selectStatement
                = "SELECT " 
            <If Loop>
               <IsComboBox (Db)>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow=[0]>
            + "     [A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]"
               <IsComboBox (Db)>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow<>[0]>
            + "    ,[A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]"
               <IsComboBox (Db)>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow=[0]>
            + "     [<ROwner>].[<RTable>].[<RDisplayField>] "
               <IsComboBox (Db)>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow<>[0]>
            + "    ,[<ROwner>].[<RTable>].[<RDisplayField>] "
               <IsNotComboBox (Db)>
               <And>
               <IsCurRow=[0]>
            + "     [<Owner>].[<Table>].[<Field>] "
               <IsNotComboBox (Db)>
               <And>
               <IsCurRow<>[0]>
            + "    ,[<Owner>].[<Table>].[<Field>] "
            </If Loop>
            + "FROM " 
            + "     [<Owner>].[<Table>] " 
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNull>
            + "LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNull>
            + "LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNotNull>
            + "INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNotNull>
            + "INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
            </If Loop>
            + "WHERE "
            + "     [<DOwner>].[<DTable>].[<DRField>] = @R<DRField> "
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] < LTRIM(RTRIM(@<RDisplayField><MiscTag>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] < LTRIM(RTRIM(@<RDisplayField><MiscTag>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] < LTRIM(RTRIM(@<RDisplayField>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] < LTRIM(RTRIM(@<RDisplayField>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] < LTRIM(RTRIM(@<Field>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] < LTRIM(RTRIM(@<Field>))) " 
</If Loop>
                + "";
        } else if  (sCondition == "Equal or more than...") {
            selectStatement
                = "SELECT "
            <If Loop>
               <IsComboBox (Db)>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow=[0]>
            + "     [A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]"
               <IsComboBox (Db)>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow<>[0]>
            + "    ,[A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]"
               <IsComboBox (Db)>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow=[0]>
            + "     [<ROwner>].[<RTable>].[<RDisplayField>] "
               <IsComboBox (Db)>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow<>[0]>
            + "    ,[<ROwner>].[<RTable>].[<RDisplayField>] "
               <IsNotComboBox (Db)>
               <And>
               <IsCurRow=[0]>
            + "     [<Owner>].[<Table>].[<Field>] "
               <IsNotComboBox (Db)>
               <And>
               <IsCurRow<>[0]>
            + "    ,[<Owner>].[<Table>].[<Field>] "
            </If Loop>
            + "FROM " 
            + "     [<Owner>].[<Table>] " 
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNull>
            + "LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNull>
            + "LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNotNull>
            + "INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNotNull>
            + "INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
            </If Loop>
            + "WHERE "
            + "     [<DOwner>].[<DTable>].[<DRField>] = @R<DRField> "
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] >= LTRIM(RTRIM(@<RDisplayField><MiscTag>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] >= LTRIM(RTRIM(@<RDisplayField><MiscTag>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] >= LTRIM(RTRIM(@<RDisplayField>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] >= LTRIM(RTRIM(@<RDisplayField>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] >= LTRIM(RTRIM(@<Field>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] >= LTRIM(RTRIM(@<Field>))) " 
</If Loop>
                + "";
        } else if (sCondition == "Equal or less than...") {
            selectStatement 
                = "SELECT "
            <If Loop>
               <IsComboBox (Db)>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow=[0]>
            + "     [A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]"
               <IsComboBox (Db)>
	       <And>
	       <IsMiscTag>
               <And>
               <IsCurRow<>[0]>
            + "    ,[A<MiscTag>].[<RDisplayField>] as [<RDisplayField><MiscTag>]"
               <IsComboBox (Db)>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow=[0]>
            + "     [<ROwner>].[<RTable>].[<RDisplayField>] "
               <IsComboBox (Db)>
	       <And>
	       <IsNotMiscTag>
               <And>
               <IsCurRow<>[0]>
            + "    ,[<ROwner>].[<RTable>].[<RDisplayField>] "
               <IsNotComboBox (Db)>
               <And>
               <IsCurRow=[0]>
            + "     [<Owner>].[<Table>].[<Field>] "
               <IsNotComboBox (Db)>
               <And>
               <IsCurRow<>[0]>
            + "    ,[<Owner>].[<Table>].[<Field>] "
            </If Loop>
            + "FROM " 
            + "     [<Owner>].[<Table>] " 
            <If Loop>
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNull>
            + "LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNull>
            + "LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsMiscTag>
	       <And>
	       <IsNotNull>
            + "INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>] "
               <IsRelated>
	       <And>
	       <IsNotMiscTag>
	       <And>
	       <IsNotNull>
            + "INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>] "
            </If Loop>
            + "WHERE "
            + "     [<DOwner>].[<DTable>].[<DRField>] = @R<DRField> "
<If Loop>
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] <= LTRIM(RTRIM(@<RDisplayField><MiscTag>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<RDisplayField><MiscTag> IS NULL OR @<RDisplayField><MiscTag> = '' OR [A<MiscTag>].[<RDisplayField>] <= LTRIM(RTRIM(@<RDisplayField><MiscTag>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] <= LTRIM(RTRIM(@<RDisplayField>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsRelated>
	       <And>
	       <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<RDisplayField> IS NULL OR @<RDisplayField> = '' OR [<ROwner>].[<RTable>].[<RDisplayField>] <= LTRIM(RTRIM(@<RDisplayField>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
                + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] <= LTRIM(RTRIM(@<Field>))) " 
     <IsNotText>
     <And>
     <IsNotNText>
     <And>
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
                + "AND   (@<Field> IS NULL OR @<Field> = '' OR [<Table>].[<Field>] <= LTRIM(RTRIM(@<Field>))) " 
</If Loop>
                + "";
        }
        SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
        selectCommand.CommandType = CommandType.Text;
    <If Loop>
   	<IsNotText>
   	<And>
   	<IsNotNText>
        <And>
        <IsRelated>
	       <And>
	       <IsMiscTag>
        if (sField == "<FieldC>") {
            selectCommand.Parameters.AddWithValue("@<RDisplayField><MiscTag>", sValue);
        } else {
            selectCommand.Parameters.AddWithValue("@<RDisplayField><MiscTag>", DBNull.Value); }
   	<IsNotText>
   	<And>
   	<IsNotNText>
        <And>
        <IsRelated>
	       <And>
	       <IsNotMiscTag>
        if (sField == "<FieldC>") {
            selectCommand.Parameters.AddWithValue("@<RDisplayField>", sValue);
        } else {
            selectCommand.Parameters.AddWithValue("@<RDisplayField>", DBNull.Value); }
   	<IsNotText>
   	<And>
   	<IsNotNText>
        <And>
        <IsNotRelated>
        if (sField == "<FieldC>") {
            selectCommand.Parameters.AddWithValue("@<FieldU>", sValue);
        } else {
            selectCommand.Parameters.AddWithValue("@<FieldU>", DBNull.Value); }
    </If Loop>
            selectCommand.Parameters.AddWithValue("@R<DRField>", <DRField>);
        DataTable dt = new DataTable();
        try
        {
            connection.Open();
            SqlDataReader reader = selectCommand.ExecuteReader();
            if (reader.HasRows) {
                dt.Load(reader); }
            reader.Close();
        }
        catch (SqlException)
        {
            return dt;
        }
        finally
        {
            connection.Close();
        }
        return dt;
    }

    public static <OwnerU>_<TableU>Class Select_Record(<OwnerU>_<TableU>Class cls<OwnerU>_<TableU>Para)
    {
        <OwnerU>_<TableU>Class cls<OwnerU>_<TableU> = new <OwnerU>_<TableU>Class();
        SqlConnection connection = <Database>DataClass.GetConnection();
        string selectStatement
            = "SELECT " 
            <Loop>
            + "    <SF[,]>[<Field>] "
            </Loop>
            + "FROM "
            + "     [<Owner>].[<Table>] "
            + "WHERE "
            <If Loop>
               <IsPKey>
            + " <SF[AND ]>[<Field>] = @<Field> "
            </If Loop>
            <If Loop>
               <IsNotPKey>
               <And>
               <IsIdentity>
            + "    [<Field>] = @<Field> "
            </If Loop>
            <If Loop>
               <IsNotIdentityCount>
               <And>
               <IsNotPKeyCount>
   	       <And>
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
            + "    [<Field>] = @<Field> "
               <ExitLoop>            
            </If Loop>
            + "";
        SqlCommand selectCommand = new SqlCommand(selectStatement, connection);
        selectCommand.CommandType = CommandType.Text;
        <If Loop>
           <IsPKey>
        selectCommand.Parameters.AddWithValue("@<FieldU>", cls<OwnerU>_<TableU>Para.<FieldU>);
        </If Loop>
        <If Loop>
           <IsNotPKey>
           <And>
           <IsIdentity>
        selectCommand.Parameters.AddWithValue("@<FieldU>", cls<OwnerU>_<TableU>Para.<FieldU>);
        </If Loop>
        <If Loop>
           <IsNotIdentityCount>
           <And>
           <IsNotPKeyCount>
   	   <And>
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
        selectCommand.Parameters.AddWithValue("@<FieldU>", cls<OwnerU>_<TableU>Para.<FieldU>);
           <ExitLoop>
        </If Loop>
        try
        {
            connection.Open();
            SqlDataReader reader
                = selectCommand.ExecuteReader(CommandBehavior.SingleRow);
            if (reader.Read())
            {
                <If Loop>
                    <IsNull>
                    <And>
                    <IsNullable>
                    <And>
                    <IsFloat>
                cls<OwnerU>_<TableU>.<FieldU> = reader["<Field>"] is DBNull ? null : (Decimal?)(Double?)reader["<Field>"];
                    <IsNull>
                    <And>
                    <IsNullable>
                    <And>
                    <IsReal>
                cls<OwnerU>_<TableU>.<FieldU> = reader["<Field>"] is DBNull ? null : (Decimal?)(Single?)reader["<Field>"];
                    <IsNull>
                    <And>
                    <IsNullable>
                    <And>
                    <IsNotFloat>
                    <And>
                    <IsNotReal>
                cls<OwnerU>_<TableU>.<FieldU> = reader["<Field>"] is DBNull ? null : (<VBType>?)reader["<Field>"];
                    <IsNull>
                    <And>
                    <IsNotNullable>
                cls<OwnerU>_<TableU>.<FieldU> = reader["<Field>"] is DBNull ? null : reader["<Field>"].ToString();
                    <IsNotNull>
                cls<OwnerU>_<TableU>.<FieldU> = <Convert>(reader["<Field>"]);
                </If Loop>
            }
            else
            {
                cls<OwnerU>_<TableU> = null;
            }
            reader.Close();
        }
        catch (SqlException)
        {
            return cls<OwnerU>_<TableU>;
        }
        finally
        {
            connection.Close();
        }
        return cls<OwnerU>_<TableU>;
    }

    public static bool Add(<OwnerU>_<TableU>Class cls<OwnerU>_<TableU>)
    {
        SqlConnection connection = <Database>DataClass.GetConnection();
        string insertStatement
            = "INSERT " 
            + "     [<Owner>].[<Table>] "
            + "     ( "
            <If Loop>
               <IsNotIdentity>
            + "    <SF[,]>[<Field>] "
            </If Loop>
            + "     ) "
            + "VALUES " 
            + "     ( "
            <If Loop>
               <IsNotIdentity>
            + "    <SF[,]>@<Field> "
            </If Loop>
            + "     ) "
            + "";
        SqlCommand insertCommand = new SqlCommand(insertStatement, connection);
        insertCommand.CommandType = CommandType.Text;
        <If Loop>
           <IsNotIdentity>
           <And>
           <IsNull>
           <And>
           <IsNullable>
        if (cls<OwnerU>_<TableU>.<FieldU>.HasValue == true) {
            insertCommand.Parameters.AddWithValue("@<FieldU>", cls<OwnerU>_<TableU>.<FieldU>);
        } else {
            insertCommand.Parameters.AddWithValue("@<FieldU>", DBNull.Value); }
           <IsNotIdentity>
           <And>
           <IsNull>
           <And>
           <IsNotNullable>
        if (cls<OwnerU>_<TableU>.<FieldU> != null) {
            insertCommand.Parameters.AddWithValue("@<FieldU>", cls<OwnerU>_<TableU>.<FieldU>);
        } else {
            insertCommand.Parameters.AddWithValue("@<FieldU>", DBNull.Value); }
           <IsNotIdentity>
           <And>
           <IsNotNull>
        insertCommand.Parameters.AddWithValue("@<FieldU>", cls<OwnerU>_<TableU>.<FieldU>);
        </If Loop>
        try
        {
            connection.Open();
            int count = insertCommand.ExecuteNonQuery();
            if (count > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        catch (SqlException)
        {
            return false;
        }
        finally
        {
            connection.Close();
        }
    }

    public static bool Update(<OwnerU>_<TableU>Class old<OwnerU>_<TableU>Class, 
           <OwnerU>_<TableU>Class new<OwnerU>_<TableU>Class)
    {
        SqlConnection connection = <Database>DataClass.GetConnection();
        string updateStatement
            = "UPDATE "  
            + "     [<Owner>].[<Table>] "
            + "SET "
            <If Loop>
               <IsNotIdentity>
            + "    <SF[,]>[<Field>] = @New<Field> "
            </If Loop>
            + "WHERE "
            <If Loop>
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNotNull>
               <And>
               <IsCurRow=[0]>
            + "     [<Field>] = @Old<Field> " 
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNotNull>
               <And>
               <IsCurRow<>[0]>
            + " AND [<Field>] = @Old<Field> " 
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNull>
               <And>
               <IsCurRow=[0]>
            + "     ((@Old<FieldU> IS NULL AND [<Field>] IS NULL) OR [<Field>] = @Old<Field>) " 
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNull>
               <And>
               <IsCurRow<>[0]>
            + " AND ((@Old<FieldU> IS NULL AND [<Field>] IS NULL) OR [<Field>] = @Old<Field>) " 
            </If Loop>
            + "";
        SqlCommand updateCommand = new SqlCommand(updateStatement, connection);
        updateCommand.CommandType = CommandType.Text;
        <If Loop>
           <IsNotIdentity>
           <And>
           <IsNull>
           <And>
           <IsNullable>
        if (new<OwnerU>_<TableU>Class.<FieldU>.HasValue == true) {
            updateCommand.Parameters.AddWithValue("@New<FieldU>", new<OwnerU>_<TableU>Class.<FieldU>);
        } else {
            updateCommand.Parameters.AddWithValue("@New<FieldU>", DBNull.Value); }
           <IsNotIdentity>
           <And>
           <IsNull>
           <And>
           <IsNotNullable>
        if (new<OwnerU>_<TableU>Class.<FieldU> != null) {
            updateCommand.Parameters.AddWithValue("@New<FieldU>", new<OwnerU>_<TableU>Class.<FieldU>);
        } else {
            updateCommand.Parameters.AddWithValue("@New<FieldU>", DBNull.Value); }
           <IsNotIdentity>
           <And>
           <IsNotNull>
        updateCommand.Parameters.AddWithValue("@New<FieldU>", new<OwnerU>_<TableU>Class.<FieldU>);
        </If Loop>
        <If Loop>
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNotNull>
        updateCommand.Parameters.AddWithValue("@Old<FieldU>", old<OwnerU>_<TableU>Class.<FieldU>);
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNull>
           <And>
           <IsNullable>
        if (old<OwnerU>_<TableU>Class.<FieldU>.HasValue == true) {
            updateCommand.Parameters.AddWithValue("@Old<FieldU>", old<OwnerU>_<TableU>Class.<FieldU>);
        } else {
            updateCommand.Parameters.AddWithValue("@Old<FieldU>", DBNull.Value); }
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNull>
           <And>
           <IsNotNullable>
        if (old<OwnerU>_<TableU>Class.<FieldU> != null) {
            updateCommand.Parameters.AddWithValue("@Old<FieldU>", old<OwnerU>_<TableU>Class.<FieldU>);
        } else {
            updateCommand.Parameters.AddWithValue("@Old<FieldU>", DBNull.Value); }
        </If Loop>
        try
        {
            connection.Open();
            int count = updateCommand.ExecuteNonQuery();
            if (count > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        catch (SqlException)
        {
            return false;
        }
        finally
        {
            connection.Close();
        }
    }

    public static bool Delete(<OwnerU>_<TableU>Class cls<OwnerU>_<TableU>)
    {
        SqlConnection connection = <Database>DataClass.GetConnection();
        string deleteStatement
            = "DELETE FROM "  
            + "     [<Owner>].[<Table>] "
            + "WHERE " 
            <If Loop>
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNotNull>
               <And>
               <IsCurRow=[0]>
            + "     [<Field>] = @Old<Field> " 
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNotNull>
               <And>
               <IsCurRow<>[0]>
            + " AND [<Field>] = @Old<Field> " 
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNull>
               <And>
               <IsCurRow=[0]>
            + "     ((@Old<FieldU> IS NULL AND [<Field>] IS NULL) OR [<Field>] = @Old<Field>) " 
               <IsNotText>
               <And>
               <IsNotNText>
               <And>
               <IsNotXML>
               <And>
               <IsNull>
               <And>
               <IsCurRow<>[0]>
            + " AND ((@Old<FieldU> IS NULL AND [<Field>] IS NULL) OR [<Field>] = @Old<Field>) " 
            </If Loop>
            + "";
        SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection);
        deleteCommand.CommandType = CommandType.Text;
        <If Loop>
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNotNull>
        deleteCommand.Parameters.AddWithValue("@Old<FieldU>", cls<OwnerU>_<TableU>.<FieldU>);
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNull>
           <And>
           <IsNullable>
        if (cls<OwnerU>_<TableU>.<FieldU>.HasValue == true) {
            deleteCommand.Parameters.AddWithValue("@Old<FieldU>", cls<OwnerU>_<TableU>.<FieldU>);
        } else {
            deleteCommand.Parameters.AddWithValue("@Old<FieldU>", DBNull.Value); }
           <IsNotText>
           <And>
           <IsNotNText>
           <And>
           <IsNotXML>
           <And>
           <IsNull>
           <And>
           <IsNotNullable>
        if (cls<OwnerU>_<TableU>.<FieldU> != null) {
            deleteCommand.Parameters.AddWithValue("@Old<FieldU>", cls<OwnerU>_<TableU>.<FieldU>);
        } else {
            deleteCommand.Parameters.AddWithValue("@Old<FieldU>", DBNull.Value); }
        </If Loop>
        try
        {
            connection.Open();
            int count = deleteCommand.ExecuteNonQuery();
            if (count > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        catch (SqlException)
        {
            return false;
        }
        finally
        {
            connection.Close();
        }
    }

    public static bool Delete(<DRType> <DRField>)
    {
        SqlConnection connection = <Database>DataClass.GetConnection();
        string deleteStatement
            = "DELETE FROM "  
            + "     [<Owner>].[<Table>] "
            + "WHERE " 
            + "     [<DRField>] = @<DRField> "
            + "";
        SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection);
        deleteCommand.CommandType = CommandType.Text;
        deleteCommand.Parameters.AddWithValue("@<DRField>", <DRField>);
        try
        {
            connection.Open();
            int count = deleteCommand.ExecuteNonQuery();
            if (count > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        catch (SqlException ex)
        {
            throw ex;
        }
        finally
        {
            connection.Close();
        }
    }

}

